EDA1
No Headings
The table of contents shows headings in notebooks and supported files.
- File
- Edit
- View
- Run
- Kernel
- Settings
- Help
[9]:
| Unnamed: 0 | Ozone | Solar.R | Wind | Temp C | Month | Day | Year | Temp | Weather | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 41.0 | 190.0 | 7.4 | 67 | 5 | 1 | 2010 | 67 | S |
| 1 | 2 | 36.0 | 118.0 | 8.0 | 72 | 5 | 2 | 2010 | 72 | C |
| 2 | 3 | 12.0 | 149.0 | 12.6 | 74 | 5 | 3 | 2010 | 74 | PS |
| 3 | 4 | 18.0 | 313.0 | 11.5 | 62 | 5 | 4 | 2010 | 62 | S |
| 4 | 5 | NaN | NaN | 14.3 | 56 | 5 | 5 | 2010 | 56 | S |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 153 | 154 | 41.0 | 190.0 | 7.4 | 67 | 5 | 1 | 2010 | 67 | C |
| 154 | 155 | 30.0 | 193.0 | 6.9 | 70 | 9 | 26 | 2010 | 70 | PS |
| 155 | 156 | NaN | 145.0 | 13.2 | 77 | 9 | 27 | 2010 | 77 | S |
| 156 | 157 | 14.0 | 191.0 | 14.3 | 75 | 9 | 28 | 2010 | 75 | S |
| 157 | 158 | 18.0 | 131.0 | 8.0 | 76 | 9 | 29 | 2010 | 76 | C |
158 rows × 10 columns
<class 'pandas.core.frame.DataFrame'> RangeIndex: 158 entries, 0 to 157 Data columns (total 10 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 Unnamed: 0 158 non-null int64 1 Ozone 120 non-null float64 2 Solar.R 151 non-null float64 3 Wind 158 non-null float64 4 Temp C 158 non-null object 5 Month 158 non-null object 6 Day 158 non-null int64 7 Year 158 non-null int64 8 Temp 158 non-null int64 9 Weather 155 non-null object dtypes: float64(3), int64(4), object(3) memory usage: 12.5+ KB
Unnamed: 0 Ozone Solar.R Wind Temp C Month Day Year Temp Weather 0 1 41.0 190.0 7.4 67 5 1 2010 67 S 1 2 36.0 118.0 8.0 72 5 2 2010 72 C 2 3 12.0 149.0 12.6 74 5 3 2010 74 PS 3 4 18.0 313.0 11.5 62 5 4 2010 62 S 4 5 NaN NaN 14.3 56 5 5 2010 56 S .. ... ... ... ... ... ... ... ... ... ... 153 154 41.0 190.0 7.4 67 5 1 2010 67 C 154 155 30.0 193.0 6.9 70 9 26 2010 70 PS 155 156 NaN 145.0 13.2 77 9 27 2010 77 S 156 157 14.0 191.0 14.3 75 9 28 2010 75 S 157 158 18.0 131.0 8.0 76 9 29 2010 76 C [158 rows x 10 columns]
<class 'pandas.core.frame.DataFrame'> (158, 10) 1580
[27]:
| Ozone | Solar.R | Wind | Month | Day | Year | Temp | Weather | |
|---|---|---|---|---|---|---|---|---|
| 0 | 41.0 | 190.0 | 7.4 | 5 | 1 | 2010 | 67 | S |
| 1 | 36.0 | 118.0 | 8.0 | 5 | 2 | 2010 | 72 | C |
| 2 | 12.0 | 149.0 | 12.6 | 5 | 3 | 2010 | 74 | PS |
| 3 | 18.0 | 313.0 | 11.5 | 5 | 4 | 2010 | 62 | S |
| 4 | NaN | NaN | 14.3 | 5 | 5 | 2010 | 56 | S |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 153 | 41.0 | 190.0 | 7.4 | 5 | 1 | 2010 | 67 | C |
| 154 | 30.0 | 193.0 | 6.9 | 9 | 26 | 2010 | 70 | PS |
| 155 | NaN | 145.0 | 13.2 | 9 | 27 | 2010 | 77 | S |
| 156 | 14.0 | 191.0 | 14.3 | 9 | 28 | 2010 | 75 | S |
| 157 | 18.0 | 131.0 | 8.0 | 9 | 29 | 2010 | 76 | C |
158 rows × 8 columns
<class 'pandas.core.frame.DataFrame'> RangeIndex: 158 entries, 0 to 157 Data columns (total 8 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 Ozone 120 non-null float64 1 Solar.R 151 non-null float64 2 Wind 158 non-null float64 3 Month 158 non-null object 4 Day 158 non-null int64 5 Year 158 non-null int64 6 Temp 158 non-null int64 7 Weather 155 non-null object dtypes: float64(3), int64(3), object(2) memory usage: 10.0+ KB
<class 'pandas.core.frame.DataFrame'> RangeIndex: 158 entries, 0 to 157 Data columns (total 8 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 Ozone 120 non-null float64 1 Solar.R 151 non-null float64 2 Wind 158 non-null float64 3 Month 157 non-null float64 4 Day 158 non-null int64 5 Year 158 non-null int64 6 Temp 158 non-null int64 7 Weather 155 non-null object dtypes: float64(4), int64(3), object(1) memory usage: 10.0+ KB
[33]:
| Ozone | Solar.R | Wind | Month | Day | Year | Temp | Weather | |
|---|---|---|---|---|---|---|---|---|
| 156 | 14.0 | 191.0 | 14.3 | 9.0 | 28 | 2010 | 75 | S |
[35]:
data1[data1.duplicated(keep=False)]
[35]:
| Ozone | Solar.R | Wind | Month | Day | Year | Temp | Weather | |
|---|---|---|---|---|---|---|---|---|
| 150 | 14.0 | 191.0 | 14.3 | 9.0 | 28 | 2010 | 75 | S |
| 156 | 14.0 | 191.0 | 14.3 | 9.0 | 28 | 2010 | 75 | S |
[39]:
data1.drop_duplicates(keep='first',inplace = True)
data1
[39]:
| Ozone | Solar.R | Wind | Month | Day | Year | Temp | Weather | |
|---|---|---|---|---|---|---|---|---|
| 0 | 41.0 | 190.0 | 7.4 | 5.0 | 1 | 2010 | 67 | S |
| 1 | 36.0 | 118.0 | 8.0 | 5.0 | 2 | 2010 | 72 | C |
| 2 | 12.0 | 149.0 | 12.6 | 5.0 | 3 | 2010 | 74 | PS |
| 3 | 18.0 | 313.0 | 11.5 | 5.0 | 4 | 2010 | 62 | S |
| 4 | NaN | NaN | 14.3 | 5.0 | 5 | 2010 | 56 | S |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 152 | 20.0 | 223.0 | 11.5 | 9.0 | 30 | 2010 | 68 | S |
| 153 | 41.0 | 190.0 | 7.4 | 5.0 | 1 | 2010 | 67 | C |
| 154 | 30.0 | 193.0 | 6.9 | 9.0 | 26 | 2010 | 70 | PS |
| 155 | NaN | 145.0 | 13.2 | 9.0 | 27 | 2010 | 77 | S |
| 157 | 18.0 | 131.0 | 8.0 | 9.0 | 29 | 2010 | 76 | C |
157 rows × 8 columns
[ ]:
Common Tools
No metadata.
Advanced Tools
No metadata.
Anaconda Assistant
AI-powered coding, insights and debugging in your notebooks.
To enable the following extensions, create an account or sign in.
- Anaconda Assistant4.1.0
- Coming soon!
- Data Catalogs
- Panel Deployments
- Sharing
Already have an account? Sign In
For more information, read our Anaconda Assistant documentation.
![Python [conda env:base] *](./EDA1_files/logo-64x64.png)